CREATE EXTERNAL TABLE `spmi_ods`.`spmn_piece_exp`(`id` bigint COMMENT '自增ID', `piece_fee_id` bigint COMMENT '派件费报价ID', `begin_num` double COMMENT '条件表达式开始数字', `end_num` double COMMENT '条件表达式结束数字', `billing_condition` string COMMENT '计费条件', `billing_expression` string COMMENT '计算公式', `billing_type` smallint COMMENT '计费类型1:W重量 2:P件数', `sort` smallint COMMENT '排序')
COMMENT '派件费报价【公式表】'
PARTITIONED BY (`dt` string COMMENT '更新/创建日期 (yyyy-MM-dd)')
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '1'
)
STORED AS
  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION 'hdfs://yl-bg-hdp/dw/hive/spmi_ods.db/external/spmn_piece_exp';